use db ;
SELECT * FROM emp where department = 'HR' ;
SELECT * FROM emp where department = 'database' ;
SELECT * FROM emp where salary = 50000 ;
SELECT * FROM emp where salary = 20000 ;



SELECT * FROM emp where department = 'HR' ;
SELECT * FROM emp where department <> 'HR' ;

SELECT * FROM emp where salary > 20000 ;
SELECT * FROM emp where salary < 20000 ;
SELECT * FROM emp where salary <= 20000 ;
SELECT * FROM emp where salary >= 20000 ;

use db;

SELECT * FROM emp ;
SELECT * FROM emp where department = 'HR';
SELECT * FROM emp where department  between  'HR' and 'IT';
SELECT * FROM emp where age   between 26 and 28;
SELECT * FROM emp where age   between 28 and 40;

SELECT * FROM emp where age in (26, 28,34);
SELECT * FROM emp where ag = 34;

SELECT * FROM emp where department  in ('HR', 'IT', 'Database');
SELECT * FROM emp where department not in ('HR', 'IT', 'Database');



SELECT * FROM emp where department is null;
SELECT * FROM emp where department is not  null;



SELECT * FROM emp where  first_name like 'H%' ;
SELECT * FROM emp where  first_name like 'Hik%' ;

SELECT * FROM emp where  first_name like '%ik%';
SELECT * FROM emp where  last_name like 'Ah%ad%';

SELECT * FROM emp where  salary like '50%';

SELECT * FROM emp where  last_name  like 'S%';
SELECT * FROM emp where  last_name not like 'S%';

SELECT * FROM emp where  salary not like '50%';